How to get @@error and @@rowcount at the same time?

Question

Anonymous User · Answer

If @@Rowcount is checked after Error checking statement then it will 
have 0 as the value of @@Recordcount as it would have been reset.
And if @@Recordcount is checked before the error-checking statement then
 @@Error would get reset. To get @@error and @@rowcount at the same time
 do both in same statement and store them in local variable. SELECT @RC =
 @@ROWCOUNT, @ER = @@ERROR

interview

How to get @@error and @@rowcount at the same time?

Anonymous User

Can you answer this question?

1 Answers

Liked By